MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Role = 1667

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
217705 66.542.15 0 0 345200 Drawings and Prints 11 Book 97 Guide to the art of illuminating and missal painting. . .with eight pages of lithographic illustrations           Author|Publisher|Author|Author 1667   W. & G. Audsley|George Rowney & Co.|William James Audsley|George Ashdown Audsley British|London|British, born 1833|British, Elgin, Scotland 1838–1925 New York   Audsley, W. & G.|Rowney, George & Co.|Audsley, William James|Audsley, George Ashdown 21402 British|British|British|British, Scottish 1187 1840 |1783 |1833 |1838 1900 |1900 |1933 |1925 1862 1862 1862 Illustrations: lithography 28996 7 1/2 x 4 15/16 in. (19 x 12.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
222951 55.643.1 0 0 350521 Drawings and Prints 11 Book 97 Illustrated Catalogue of glassware, from factories F-G-H-K-L-P           Author|Publisher|Author|Author 1667   James Gillinder and Sons|Ripley & Co.|United States Glass Co.|O'Hara Glass Co. American, 1861–ca. 1930|Pittsburg, Pennsylvania|Pittsburgh, Pennsylvania|American   Gillinder and Sons, James|Ripley & Co.|United States Glass Co.|O'Hara Glass Co. 25087 American|American|American|American 97 1861 |1800 |1891 |1800 1930 |1950 |1950 |1950 1881–90 1881 1890 Photomechanical process 34070 9 x 12 in. (22.9 x 30.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1955   Greensburg 1374                   Books 442   Metropolitan Museum of Art, New York, NY 1
228181 68.526.17 0 0 355811 Drawings and Prints 11 Book 97 Emblems, Divine and Moral           Author|Publisher|Author|Author 1667 Preface by|Preface by Francis Quarles|John Bennet|Reverend Augustus Montague Toplady|Reverend John Ryland British, Romford, Essex 1592–1644|London|British, 1740–1778|British, Warwick 1753–1825 Bristol   Quarles, Francis|Bennet, John|Toplady, Augustus Montague|Ryland, John Reverend 28887 British|British|British|British 177 1592 |1800 |1740 |1753 1644 |1900 |1778 |1825 1839 1839 1839 Illustrations: engraving 28942 7 5/16 x 4 5/16 in. (18.5 x 11 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1968                       Books 442   Metropolitan Museum of Art, New York, NY 1
229965 64.661.12(1) 0 0 357635 Drawings and Prints 11 Book 97 The Mastepieces of the Centennial International Exhibition Illustrated, Vol. 1: Fine Arts           Author|Publisher|Author|Author 1667   Edward Strahan (Earl Shinn)|Gebbie and Barrie, Philadelphia|Joseph Miller Wilson|Walter Smith American, 1838–1886|American, 1832–1902|American, 1836–1886   Strahan, Edward|Gebbie and Barrie|Wilson, Joseph Miller|Smith, Walter 30085 American|American 5 1838 |1848 |1832 |1836 1886 |1880 |1902 |1886 ca. 1876 1876 1876 Illustrations: engravings 33775 11 11/16 × 8 3/8 × 1 3/4 in. (29.7 × 21.3 × 4.5 cm) Gift of the Commercial Museum Division, Trade and Convention Center, 1964                       Books 442   Metropolitan Museum of Art, New York, NY 1
230357 67.840.6(1–3) 0 0 358044 Drawings and Prints 11 Book 97 The History of Four-Footed Beasts and Serpents and Insects           Author|Publisher|Author|Author 1667   Edward Topsell|Da Capo Press|Thomas Moffett|Conrad Gesner British, 1572–1625|New York, NY|British, 1553–1604|Swiss, Zurich 1516–1565 Zurich   Topsell, Edward|Da Capo Press|Moffett, Thomas|Gesner, Conrad 30341 British|American|British|Swiss 2296 1572 |1900 |1553 |1516 1625 |1999 |1604 |1565 1967 1967 1967     Gift of A. Hyatt Mayor, 1967                       Books 442   Metropolitan Museum of Art, New York, NY 1
240381 41.100.499 0 0 368497 Drawings and Prints 11 Book 97 M. Vitruvii Pollionis De Architectura Libri Decem           Author|Publisher|Author|Author 1667 Written by|Annotated by|Written by Marcus Pollio Vitruvius|Jean de Tournes|Guillaume Philander|Giorgio Agricola Roman, active late 1st century B.C.|French, 1504–1564|French, 1505–1565|German, 1494–1555   Vitruvius, Marcus|Tournes, Jean de|Guillaume Philander|Agricola, Giorgio 33343 Italian|French|French|German 2612 -0100 |1504 |1505 |1494 0001 |1564 |1565 |1555 1586 1586 1586 Printed book with woodcut illustrations 33727 Overall: 9 13/16 x 7 1/16 x 1 7/16 in. (24.9 x 18 x 3.6 cm) Bequest of W. Gedney Beatty, 1941   Lyon 312                   Books 442   Metropolitan Museum of Art, New York, NY 1
431562 AE25 .E532 1758 Q 1 1 716639 The Libraries 20   Encyclopédie, ou Dictionnaire raisonné des sciences, des arts et des métiers, par une société de gens de lettres           Author|Publisher|Author|Author 1667   Ottaviano Diodati|Vincenzo Giuntini|Jean Le Rond d'Alembert|Denis Diderot Italian, 1716–1786|French, 1717–1783|French, 1713–1784   Diodati, Ottaviano|Giuntini, Vincenzo|Alembert, Jean Le Rond d'|Diderot, Denis 55030   1716 |1717 |1713 1786 |1783 |1784 1758–1771 1758 1771   17 volumes, illustrations, height: 16 9/16 in. (42 cm) Bequest of Marianne Khuner   Lucca 1259     Italy 14                 Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 367.278ms · Data license: CC0 · Data source: metmuseum/openaccess